﻿IF EXISTS (SELECT * from sys.procedures p left join sys.schemas s on p.schema_id = s.schema_id where p.name='account_select' and s.name='Budget')
DROP PROCEDURE [Budget].account_select
GO
CREATE PROCEDURE [Budget].account_select 
@PK uniqueidentifier
AS
BEGIN
SELECT 	
	[Accounts].[id_account] AS [PK],
	[Accounts].[name] AS [Name]
FROM 
	[Accounts] 
WHERE
	[Accounts].[id_account] = @PK 
END